const Goods = require('../model/goods.model')
class GoodsService {
  async createGoods(goods) {
    const res = await Goods.create(goods)
    return res.dataValues
  }
  async updataGoods(id, goods) {
    const res = await Goods.update(goods, { where: { id } })
    return res[0] > 0 ? true : false
  }
  async removeGoods(id) {
    const res = await Goods.destroy({ where: { id } })
    return res > 0 ? true : false
  }
  async restoreGoods(id) {
    const res = await Goods.restore({ where: { id } })
    return res > 0 ? true : false
  }
  async findGoods(pageNum, pageSize) {
    // // 获取总数
    // const count = await Goods.count()

    // const offset = (pageNum - 1) * pageSize
    // //  获取分页
    // const rows = await Goods.findAll({
    //   attributes: ['id', 'goods_name','goods_num','goods_pirce','goods_img'],
    //   offset: offset,
    //   limit: pageSize * 1
    // })
    const offset = (pageNum - 1) * pageSize
    const { count, rows } = await Goods.findAndCountAll({
      attributes: ['id', 'goods_name','goods_num','goods_pirce','goods_img'],
      offset: offset,
      limit: pageSize * 1
    })

    return {
      pageNum,
      pageSize,
      total: count,
      list: rows
    }

  }
}
module.exports = new GoodsService()